﻿CREATE TABLE [dbo].[Task]
(
	TaskId int not null identity(1,1),
	Summary nvarchar(200) not null,
	[Description] nvarchar(max) not null,
	ProjectId int not null,
	AddDate datetime not null default getdate(),
	ModifyDate datetime null,
	StatusId int not null,
	AssignedUserId int null,
	CreatedUserId int not null,
	[Priority] tinyint not null,
	CategoryId int not null,
	ViewStatus tinyint not null,
	StartDate datetime null,
	EndDate datetime null
)
